SEARCH OPERATORS

Operator

Function

Description

Asterisk (*)

Wildcard

Use the wildcard operator (*) in the Left-Side Search bar and in the column filters to quickly find partial words and records with multiple variations regardless of length or alphanumeric character. 

Number of Wildcard Operators / Wildcard Placement:

Use one or two wildcard operators in a single search:

• Use a single wildcard operator at the front, middle or end of a search phrase. For example, Joh* returns all records that start with Joh, including John, Johnathon, Johnnie, and John’s and *ville returns Smithville, Knoxville and Abbotsville.

• Use two wildcard operators when one is at the front and one is at the end of the phrase.  For example, *nvoic* returns all records that contain the sequence nvoic, including AR Invoice, AP Invoices, and Intl Invoicing.

Length of Search Phrase:

• You must search on at least three characters to use the wildcard in the Left-Side search bar. For example, Joh* returns all records that start with Joh, including John, Johnathon, Johnnie, John’s, etc.

• You are able to search on one or more characters in the column filters.   For example, J* returns all records that start with J.

AND

Include

Find records that contain both words. 

For example, searching on Smith AND John returns records containing John and records containing Smith.  

Searching on Smith AND John AND Leon returns records containing Smith and records containing John and records containing Leon.

You must enter this operator in capital letters.

You are able to use this operator in conjunction with NOT.

NOT

Exclude

Eliminates all results that contain the criteria directly following NOT. 

For example, NOT 2001 prevents any record that contains 2001 from being returned.

You are able to use this operator in conjunction with AND and OR. 

Quotation marks (“”)

Phrase

Find records containing the exact phrase in quotation marks. 

For example, “John Richard Smith” returns only records containing the entire phrase John Richard Smith.  Entries for Richard John Smith are not included.

OR

Or

Find records containing either word. 

For example, Smith OR John returns records containing Smith and records containing John but not both words.  Searching on Smith OR John OR Leon returns records containing Smith and records containing John and records containing Leon, but not all three words.

You must enter this operator in capital letters.

You are able to use this operator in conjunction with NOT.

Space ( )

Or

This operator functions like OR.  See above.

Comma (,)

Or

This operator functions like OR.  See above.